Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ComponentID (PK) | A unique system assigned identifier for the RawMaterialComponent | ID_COM | Identity | integer | |
ItemID (FK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | Item(AS_ITM) |
UnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
UnitQuantity | The quantity of the RawItem that make up a single serving of the RawMaterialComponent | QU_UN_AMT | QuantityShortCount | decimal(3,0) | |
Description | A short description denoting what the ingredient is. Eg: 5oz Ketchup/BBQ | DE_COM | DescriptionShort | varchar(255) | |